create table if not exists d_rnt_wimp_rm_ac_info_d_#{PARTITION_DATE}
 (
device_id    varchar(32) ,
sys_name    varchar(256) ,
alias    varchar(128) ,
ip_addr    varchar(20) ,
mac_addr    varchar(20) ,
netmask    varchar(20) ,
city    varchar(20) ,
district    varchar(20) ,
site_name    varchar(128) ,
room    varchar(64) ,
shelf_name    varchar(256) ,
pt_location    varchar(256) ,
config_template    varchar(128) ,
nas_ip    varchar(64) ,
serial_number    varchar(128) ,
device_model    varchar(128) ,
software_name    varchar(128) ,
software_version    varchar(128) ,
vendor    varchar(20) ,
sys_location    varchar(255) ,
asset_id    varchar(40) ,
project_status    varchar(20) ,
service_system_name    varchar(20) ,
create_time    datetime ,
uplink_if_name    varchar(128) ,
hotspot_cnt    bigint ,
sw_cnt    bigint ,
max_ap_cnt    bigint ,
current_ap_cnt    bigint ,
online_ap_cnt    bigint ,
max_sta_cnt    bigint ,
is_backup    bigint ,
backup_name    varchar(256) ,
remark    varchar(256)
)   compress(5, 5)  nolock ;